Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
How to calculate the previous day?
Hi,
I have a date field dtMyDate. Can someone tell me how do I find the value of the date that is 1 day before dtMyDate? Also I am still looking for proper answers to the questions I have posted on the 6th of May 2004. Thanks in advance Prasad Vanka |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
How to calculate the previous day?
Dates are stored as the number of days from a base date, so to get the day
before, just subtract 1 dtYesterday = dtMyDate - 1 -- Regards, Tom Ogilvy "Prasad Vanka" wrote in message ... Hi, I have a date field dtMyDate. Can someone tell me how do I find the value of the date that is 1 day before dtMyDate? Also I am still looking for proper answers to the questions I have posted on the 6th of May 2004. Thanks in advance Prasad Vanka |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
How to calculate the previous day?
Hi,
Thanks for the answer. Just one more help. I have just started using VBA on excel (had done AS400 programming for 7 years). But now totally into Excel VBA. So programming is not a problem. Can you recommend any book or any website that contains example codes. My job here is to basically use/work on a master sheet in main workbook and populate detail sheets either in the main workbook or a different workbook. I want to start working on VBA properly and on the track. regards, Prasad Vanka "Tom Ogilvy" wrote in message ... Dates are stored as the number of days from a base date, so to get the day before, just subtract 1 dtYesterday = dtMyDate - 1 -- Regards, Tom Ogilvy "Prasad Vanka" wrote in message ... Hi, I have a date field dtMyDate. Can someone tell me how do I find the value of the date that is 1 day before dtMyDate? Also I am still looking for proper answers to the questions I have posted on the 6th of May 2004. Thanks in advance Prasad Vanka |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
How to calculate the previous day?
Go to this site and download the Google add-in
www.rondebruin.nl/Google.htm It is better than a single site or book. -- steveb (Remove 'NOSPAM' from email address if replying direct) "Prasad Vanka" wrote in message om... Hi, Thanks for the answer. Just one more help. I have just started using VBA on excel (had done AS400 programming for 7 years). But now totally into Excel VBA. So programming is not a problem. Can you recommend any book or any website that contains example codes. My job here is to basically use/work on a master sheet in main workbook and populate detail sheets either in the main workbook or a different workbook. I want to start working on VBA properly and on the track. regards, Prasad Vanka "Tom Ogilvy" wrote in message ... Dates are stored as the number of days from a base date, so to get the day before, just subtract 1 dtYesterday = dtMyDate - 1 -- Regards, Tom Ogilvy "Prasad Vanka" wrote in message ... Hi, I have a date field dtMyDate. Can someone tell me how do I find the value of the date that is 1 day before dtMyDate? Also I am still looking for proper answers to the questions I have posted on the 6th of May 2004. Thanks in advance Prasad Vanka |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
3-Color Scale Vlookup for Current Month/Previous/Pre-Previous | Excel Discussion (Misc queries) | |||
Automatically calculate the previous days total 'sales' | Excel Discussion (Misc queries) | |||
Calculate date for one month previous? | Excel Discussion (Misc queries) | |||
Functions for "current" & "previous" month to calculate data | Excel Worksheet Functions | |||
Calculate % variance on previous quarters. Quarter %, etc. pivot | Excel Discussion (Misc queries) |