Hi Guys,
I have a spreadsheet that I need to be able to calculate and add 21 days to any given date entered.
For example if I used today's date of 25/04/07 should return a date of 16/05/07.
How can I acheive this?
Thanks in advance.
Hi Guys,
I have a spreadsheet that I need to be able to calculate and add 21 days to any given date entered.
For example if I used today's date of 25/04/07 should return a date of 16/05/07.
How can I acheive this?
Thanks in advance.
Best Regards.
Michael
-----------------------------------
Windows Vista, Microsoft Office 2007
Hello Zyphon,
If cell A1 has the todays date from the formula =Today(), in cell A2 add the formula =A1+21.
Sincerely,
Leith Ross
Thanks for your help Leith.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks