Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
making daily calculations
I am trying to run a spreadsheet of daily calculations and I am having
trouble setting up the formulas. Here is an example of what I am trying to do: A B C 1 12345 11111 2 23456 11111 3 34567 4 My delema is that I can't figure out how to set up the formula to subtract the last day of the month from the first of the next month. Since some months have 31 days, some with 30, and the dreaded 28 of February. I am very new at this type of thing, so if there is any need of more information, please let me know. Thank you for any help. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
making daily calculations
Hi p-nut,
To get you started: =DATE(YEAR(TODAY()),MONTH(TODAY()),0) will return the last day of last month, regardless of how many days that month had. Cheers -- macropod [MVP - Microsoft Word] "p-nut" wrote in message ... I am trying to run a spreadsheet of daily calculations and I am having trouble setting up the formulas. Here is an example of what I am trying to do: A B C 1 12345 11111 2 23456 11111 3 34567 4 My delema is that I can't figure out how to set up the formula to subtract the last day of the month from the first of the next month. Since some months have 31 days, some with 30, and the dreaded 28 of February. I am very new at this type of thing, so if there is any need of more information, please let me know. Thank you for any help. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
SUMPRODUCT Help | Excel Discussion (Misc queries) | |||
complex calculations | Excel Discussion (Misc queries) | |||
Figuring daily average...function ??? | Excel Worksheet Functions | |||
Calculations crossing multiple sheets | Excel Discussion (Misc queries) |