Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Calculate a date
I think I am being extremely thick, however I am trying to work out what the
date is a week ago from today's date excluding weekends. I don't want to know how many working days ago it was, I need to know the actual date. Does anyone know how to do this? Help would be greatly appreciated as I'm really scratching my head over this one. Thanks a lot Aehan |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Calculate a date
Could you give an example?
-- Bernard V Liengme www.stfx.ca/people/bliengme remove caps from email "aehan" wrote in message ... I think I am being extremely thick, however I am trying to work out what the date is a week ago from today's date excluding weekends. I don't want to know how many working days ago it was, I need to know the actual date. Does anyone know how to do this? Help would be greatly appreciated as I'm really scratching my head over this one. Thanks a lot Aehan |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Calculate a date
You could try =TODAY()-7.
"Bernard Liengme" wrote: Could you give an example? -- Bernard V Liengme www.stfx.ca/people/bliengme remove caps from email "aehan" wrote in message ... I think I am being extremely thick, however I am trying to work out what the date is a week ago from today's date excluding weekends. I don't want to know how many working days ago it was, I need to know the actual date. Does anyone know how to do this? Help would be greatly appreciated as I'm really scratching my head over this one. Thanks a lot Aehan |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Calculate a date
Hi Bernard
A user has asked me for a formula to calculate 7 working days back from today's date. TODAY() -7 or NOW() -7 includes the weekends. So for instance if today were 19th July she would want to see 10th July as the answer, not 12th. If today were 16th July she would want to see 5th July as the answer, not 9th - and so on. I've tried NETWORDAYS, but that gives me the number of working days ago - not the date, and now I'm completely stumped. "Bernard Liengme" wrote: Could you give an example? -- Bernard V Liengme www.stfx.ca/people/bliengme remove caps from email "aehan" wrote in message ... I think I am being extremely thick, however I am trying to work out what the date is a week ago from today's date excluding weekends. I don't want to know how many working days ago it was, I need to know the actual date. Does anyone know how to do this? Help would be greatly appreciated as I'm really scratching my head over this one. Thanks a lot Aehan |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
Calculate a date
=workday(today(),-7)
(Format that cell as a date if it looks funny) aehan wrote: Hi Bernard A user has asked me for a formula to calculate 7 working days back from today's date. TODAY() -7 or NOW() -7 includes the weekends. So for instance if today were 19th July she would want to see 10th July as the answer, not 12th. If today were 16th July she would want to see 5th July as the answer, not 9th - and so on. I've tried NETWORDAYS, but that gives me the number of working days ago - not the date, and now I'm completely stumped. "Bernard Liengme" wrote: Could you give an example? -- Bernard V Liengme www.stfx.ca/people/bliengme remove caps from email "aehan" wrote in message ... I think I am being extremely thick, however I am trying to work out what the date is a week ago from today's date excluding weekends. I don't want to know how many working days ago it was, I need to know the actual date. Does anyone know how to do this? Help would be greatly appreciated as I'm really scratching my head over this one. Thanks a lot Aehan -- Dave Peterson |
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
Calculate a date
Exfellent! Thank you very much.
"Dave Peterson" wrote: =workday(today(),-7) (Format that cell as a date if it looks funny) aehan wrote: Hi Bernard A user has asked me for a formula to calculate 7 working days back from today's date. TODAY() -7 or NOW() -7 includes the weekends. So for instance if today were 19th July she would want to see 10th July as the answer, not 12th. If today were 16th July she would want to see 5th July as the answer, not 9th - and so on. I've tried NETWORDAYS, but that gives me the number of working days ago - not the date, and now I'm completely stumped. "Bernard Liengme" wrote: Could you give an example? -- Bernard V Liengme www.stfx.ca/people/bliengme remove caps from email "aehan" wrote in message ... I think I am being extremely thick, however I am trying to work out what the date is a week ago from today's date excluding weekends. I don't want to know how many working days ago it was, I need to know the actual date. Does anyone know how to do this? Help would be greatly appreciated as I'm really scratching my head over this one. Thanks a lot Aehan -- Dave Peterson |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Tricky Date calculation: How to calculate a future date | Excel Discussion (Misc queries) | |||
Auto calculate for date + days forward to yield new date | Excel Worksheet Functions | |||
formula to calculate age using birth date and current date | Excel Worksheet Functions | |||
formula to calculate future date from date in cell plus days | Excel Worksheet Functions | |||
Calculate month-end date from date in adjacent cell? | Excel Worksheet Functions |