Computer Problems? Computing.Net has over 1,000,000 posts about all things technology related! Over 90% answered within 24 hours! Click here to start participating now! Also, be sure to check out the New User Guide.
Recurring BI-weekly date formula?
Name: pficca Date: April 11, 2009 at 08:18:20 Pacific OS: Windows XP Subcategory: General
Comment:
I am trying to create a recurring date formula in Excel. i am setting up a bi-weekly "budget" and want to have the spreadsheet automatically update with next bi-weekly date. Starting on Friday 4/24/09, and then moving every 2 weeks from then on. So, the next date would be Friday 5/8, and so on. Any help that someone can provide is greatly appreciated!
Name: StuartS Date: April 11, 2009 at 09:31:42 Pacific
Reply:
Just add 14 days to the previous date.
=+A1+14
A1 contains the previous date. Dates have to be formated as dates and not entered as strings. Datas are stored in Excell as a 32 bit floating point number. You cannot do calculations on strings.
Summary: Currently im facing a issue with batch script while creating new folder. Ex., set foldername1= C:\BI_Reports\%date:~4,2%-%date:~10,4% md %foldername1% The above batch script will create new folder c...
Summary: For those interested, with alot of help I've found a solution, thank you to Alexander Zivic of Austria for pointing me towards AnyHotKey and putting together this script. SetWorkingDir %A_ScriptDir% L...
Summary: Hi, I am using MS VS.Net 2003 and C#. I am trying to setup a selection formula for date using crsytal report. I know that we have to format the date criteria, but I have no clue how to do it. I would...
0 
