| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Next Firday Date Calculation in VBA
Hi again.
In a spreadsheet I am creating I require it to show to dates. The first is very simple as it is todays date: Today() The second I cant work out. I need the second date to show the next friday after the Today date except if Today's date is a friday when it should show that. Can anyone give me a hand with the formula or code for this? Thanks Celtic_Avenger  :confused-- Message posted from http://www.ExcelForum.com |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Next Firday Date Calculation in VBA
For a formula solution assuming the date or interest is in A2
=IF(WEEKDAY(A2)=7,A2+6,A2+6-WEEKDAY(A2)) Tom Wood "Celtic_Avenger " wrote in message ... Hi again. In a spreadsheet I am creating I require it to show to dates. The first is very simple as it is todays date: Today() The second I cant work out. I need the second date to show the next friday after the Today date, except if Today's date is a friday when it should show that. Can anyone give me a hand with the formula or code for this? Thanks Celtic_Avenger --- Message posted from http://www.ExcelForum.com/ |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| A specific date used for calculation of a new date | Excel Discussion (Misc queries) | |||
| Date Calculation | Excel Worksheet Functions | |||
| Date Calculation (from entered date / 1yr later in next field) | Excel Worksheet Functions | |||
| End Date Calculation (adding a start date duration) | Excel Discussion (Misc queries) | |||
| Tricky Date calculation: How to calculate a future date | Excel Discussion (Misc queries) | |||
![Celtic_Avenger[_31_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Linear Mode
